let chren = args.form;
for(let item of chren){
	let id = item.id;
	let delivery_order_sn = item.deliveryOrderSn;
	let warehouse = item.warehouse;
	let product_id = item.productId;
	lib.dbQueryJsonArray(`SELECT
		q.product_img AS productImg,
		q.product_name AS productName,
		q.sku AS sku,
		q.shop AS shop,
		q.fnsku AS fnsku,
		s.order_sn AS orderSn,
		s.warehouse AS warehouse,
		s.create_user AS createUser,
		s.create_time AS createTime,
		s.warehousing_date AS warehousingDate,
		si.wait_quantity AS waitQuantity,
		si.good_product AS goodProduct,
		si.defective_product AS defectiveProduct,
		si.product_id AS productId
	FROM
		quality_check_storage q
		LEFT JOIN stock_in s ON q.delivery_order_sn = s.associated_po
		LEFT JOIN stock_in_product si ON s.id = si.parent_stock_in_id 
	WHERE
		q.id = ? 
		AND q.delivery_order_sn = ? 
		AND s.warehouse = ? 
		AND si.product_id =? 
		AND q.del_flag = 0`,id,delivery_order_sn,warehouse,product_id);
}
// chren.forEach(function(item,index,array){
// 	let id = item.id;
// 	let delivery_order_sn = item.deliveryOrderSn;
// 	let warehouse = item.warehouse;
// 	let product_id = item.productId;
// 	lib.dbQueryJsonArray(`SELECT
// 		q.product_img AS productImg,
// 		q.product_name AS productName,
// 		q.sku AS sku,
// 		q.shop AS shop,
// 		q.fnsku AS fnsku,
// 		s.order_sn AS orderSn,
// 		s.warehouse AS warehouse,
// 		s.create_user AS createUser,
// 		s.create_time AS createTime,
// 		si.wait_quantity AS waitQuantity,
// 		si.good_product AS goodProduct,
// 		si.defective_product AS defectiveProduct,
// 		si.product_id AS productId
// 	FROM
// 		quality_check_storage q
// 		LEFT JOIN stock_in s ON q.delivery_order_sn = s.associated_po
// 		LEFT JOIN stock_in_product si ON s.id = si.parent_stock_in_id 
// 	WHERE
// 		q.id = ? 
// 		AND q.delivery_order_sn = ? 
// 		AND s.warehouse = ? 
// 		AND si.product_id =? 
// 		AND q.del_flag = 0`,id,delivery_order_sn,warehouse,product_id);
// })